Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] equivalent of sqlload? - Mailing list pgsql-general

From Herouth Maoz
Subject Re: [GENERAL] equivalent of sqlload?
Date
Msg-id l03110703b281d221e93e@[147.233.159.109]
Whole thread Raw
In response to equivalent of sqlload?  (John Holland <jholland@isr.umd.edu>)
Responses Re: [GENERAL] equivalent of sqlload?
List pgsql-general
Tree view 
At 16:45 +0200 on 25/11/98, John Holland wrote:


> Oracle has a facility for loading in massive data files, sqlload I think
> is the name. I'd like to load some big data into PostgreSQL 6.4 for
> testing purposes. Is there a way built in or would a perl or c hack be the
> way to go?

Use the COPY command. It is preferable not to define indices (or to drop
the indices) on the table, then do the massive load with COPY, and then
define the indices.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

pgsql-general by date:

Previous
From: John Holland
Date:
Subject: equivalent of sqlload?
Next
From: Sferacarta Software
Date:
Subject: Re: [GENERAL] equivalent of sqlload?